{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lists","ALL Crest"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":49,"n_cols":43,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,0,11,1],[11,3,11,4],[11,5,11,6]]}
[]
["MODEL","BOILER TYPE","MAKE","MODEL","AHRI EFFICIENCY","FUEL","INPUT\n(btuh)","MAX.\nOUTPUT\n(btuh)","MIN.\nOUTPUT\n(btuh)","TURNDOWN RATIO","MIN-MAX. INLET PRESSURE\n(IN. W.C.)","GALLON CAPACITY","Max. Pressure Rating","Relief Valve Pressure Rating","MINIMUM FLOW RATE (GPM)","MAXIMUM FLOW RATE (GPM)","DESIGN SYSTEM \nDELTA T\n(oF)","20°F ΔT WATER FLOW (GPM)","HEAD LOSS\n(FT. OF HD.)","E.W.T.\n(oF)","L.W.T.\n(oF)","VOLTAGE/\nPHASE","TOTAL AMPS (FLA)","VENT SIZE","VENT MATERIAL","OPERATING WEIGHT   (lbs.)","DIMENSIONS",null,"Relief Valve PSI","Fuel","DeltaT","MODEL","FLOW\n20","FT/HD\n20","MODEL","FLOW\n30","FT/HD\n30","MODEL","FLOW\n40","FT/HD\n40","MODEL","FLOW\n60","FT/HD\n60"]
["FCB1000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB1000",0.96199999999999997,null,999000,961000,48100,"20:1",null,77,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",6,6,"SS, CPVC, PVC, or Polypro",1939.4099999999999,"78 x 30\nx 57-1/2",null,50,"Natural Gas",20,"FCB1000",96,8.3000000000000007,"FCB1000",64.17,6.9,"FCB1000",48,6,"FCB1000",32,5.5]
["FCB1500","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB1500",0.96199999999999997,null,1500000,1443000,{"$f":"H4/25","v":57720},"25:1",null,94,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",10,8,"SS, CPVC, PVC, or Polypro",2345.02,"78 x 30 x 64",null,75,"LP",30,"FCB1500",144,12.3,"FCB1500",96.35,8.9,"FCB1500",72,7.3,"FCB1500",78,5.8]
["FCB2000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB2000",0.96199999999999997,null,1999000,1923000,{"$f":"H5/25","v":76920},"25:1",null,111,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",13,8,"SS, CPVC, PVC, or Polypro",2621.63,"78 x 30 x 64-1/4",null,100,null,40,"FCB2000",192,14.5,"FCB2000",128.41,10.1,"FCB2000",96,8.1,"FCB2000",64,6.6]
["FCB2500","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB2500",0.96,null,2500000,2400000,120000,"20:1",null,157,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",4.5,9,"SS, CPVC, PVC, or Polypro",3554.81,"77-3/4 x 35 x 79-1/4",null,125,null,60,"FCB2500",240,8.4,"FCB2500",160.26,6.2,"FCB2500",120,5.3,"FCB2500",80,4.8]
["FCB3000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB3000",0.96,null,3000000,2883000,{"$f":"H7/20","v":144150},"20:1",null,156,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",6.5,10,"SS, CPVC, PVC, or Polypro",3582.48,"77-3/4 x 35 x 79-1/4",null,150,null,null,"FCB3000",288,8,"FCB3000",192.31,5.2,"FCB3000",144,4,"FCB3000",96,3.3]
["FCB4000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB4000",0.96,null,3999000,3843000,{"$f":"H8/20","v":192150},"20:1",null,201,160,null,45,350,null,null,null,null,null,"480V/3PH/\n60Hz",6,12,"SS, CPVC, PVC, or Polypro",4882.33,"78 x 43-1/4 x 95-1/4",null,null,null,null,"FCB4000","350*\n(Based on 22°F ΔT)",10.9,"FCB4000",256.35000000000002,7.6,"FCB4000",192,5.9,"FCB4000",128,4.4000000000000004]
["FCB5000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB5000",0.96,null,4999000,4804000,{"$f":"H9/20","v":240200},"20:1",null,254,160,null,50,600,null,null,null,null,null,"480V/3PH/\n60Hz",5,14,"Stainless Steel",5919.82,"78 x 46-1/2 x 96-1/2",null,null,null,null,"FCB5000",480,13.9,"FCB5000",320.45,10.7,"FCB5000",240,7.6,"FCB5000",160,5.5]
["FCB6000","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FCB6000",0.96,null,6000000,5766000,{"$f":"H10/20","v":288300},"20:1",null,304,160,null,60,600,null,null,null,null,null,"480V/3PH/\n60Hz",7,14,"Stainless Steel",6755.32,"78 x 50 x 102-3/4",null,null,null,null,"FCB6000",576,17.2,"FCB6000",384.62,13,"FCB6000",288,9.4,"FCB6000",192,6.8]
[]
["CONDENSATE KITS",null,null,"ECM Pumps",null,"Isolation Valves",null,null,null,null,"Natural Gas","LP",null,null,null,"Natural Gas","LP"]
["< Select >",null,null,"100208412 (20°F / FCB1000)",null,"100266962 (3” / FCB1000)",null,null,null,"FCB1000","4 to 14","8 to 14",null,null,"FCB1000","FCB1000N","FCB1000L"]
["100289581 (1000-2000)",null,null,"100208412 (20°F / FCB1500)",null,"100157681 (4” / FCB1500)",null,null,null,"FCB1500","4 to 14","8 to 14",null,null,"FCB1500","FCB1500N","FCB1500L"]
["100289582 (2500-6000)",null,null,"100277760 (20°F / FCB2000)",null,"100157681 (4” / FCB2000)",null,null,null,"FCB2000","4 to 14","8 to 14",null,null,"FCB2000","FCB2000N","FCB2000L"]
[null,null,null,"100189240 (20°F / FCB2500)",null,"100157681 (4” / FCB2500)",null,null,null,"FCB2500","4 to 14","8 to 14",null,null,"FCB2500","FCB2500N","FCB2500L"]
["< Select >"," ",null,"100189240 (20°F / FCB3000)",null,"100157681 (4” / FCB3000)",null,null,null,"FCB3000","4 to 14","8 to 14",null,null,"FCB3000","FCB3000N","FCB3000L"]
["Primary-Secondary","Primary-Secondary piping: ECM boiler pump shall be provided with each boiler and controlled via a 0-10vdc (Field Wire) signal to maintain design Delta T.  ",null,"100189240 (20°F / FCB4000)",null,"100157681 (4” / FCB4000)",null,null,null,"FCB4000","4 to 14","8 to 14",null,null,"FCB4000","FCB4000N","FCB4000L"]
["Variable Primary","Variable Primary piping: Boiler isolation valves shall be provided on the outlet of each boiler and controlled by the boiler operating system.  ",null,"100208411 (40°F / FB 1001)",null,"100280019 (6” / FCB5000) ",null,null,null,"FCB5000","4 to 14","8 to 14",null,null,"FCB5000","FCB5000N","FCB5000L"]
[null,null,null,"100208411 (40°F / FB 1501)",null,"100280019 (6” / FCB6000) ",null,null,null,"FCB6000","4 to 14","8 to 14",null,null,"FCB6000","FCB6000N","FCB6000L"]
[null,null,null,"100208412 (40°F / FB 2001)"]
[null,null,null,"100208412 (40°F / FB 2501)"]
[null,null,null,"100208412 (40°F / FB 3001)"]
[null,null,null,"100208412 (40°F / FB 3501)"]
[null,null,null,"100277760 (40°F / FB 4001)"]
[null,null,null,"100277760 (40°F / FB 5001)"]
[null,null,null,"100189240 (40°F / FB 6001)"]
[null,null,null,"100208411 (60°F / FB 1501)"]
[null,null,null,"100208411 (60°F / FB 2001)"]
[null,null,null,"100208411 (60°F / FB 2501)"]
[null,null,null,"100208411 (60°F / FB 3001)"]
[null,null,null,"100208412 (60°F / FB 4001)"]
[null,null,null,"100277760 (60°F / FB 5001)"]
[null,null,null,"100277760 (60°F / FB 6001)"]
[]
["< Select >"]
["up to 2 psi"]
["up to 10 psi"]
[]
[]
["< Select >",null,"up to 2 psi","up to 10 psi"]
[null,"FCB1000",100269922,100320058]
[null,"FCB1500",100269923,100320059]
[null,"FCB2000",100269923,100320059]
[null,"FCB2500",100269924,100320060]
[null,"FCB3000",100269924,100320060]
[null,"FCB4000",100269925,100320061]
[null,"FCB5000",100269925,100320061]
[null,"FCB6000",100320057,100320062]

{"sheet":"ALL Crest","index":1,"n_rows":37,"n_cols":27,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,6,0,10],[4,21,4,22],[0,11,0,24],[1,7,1,8],[2,7,2,8],[1,10,1,11],[2,10,2,11],[1,16,1,17],[4,23,4,26],[26,5,26,6],[4,0,4,4],[1,22,1,23],[2,22,2,23],[1,19,1,20],[2,19,2,20],[4,5,4,10],[4,11,4,20],[1,1,1,2],[2,1,2,2],[1,4,1,5],[2,4,2,5],[1,13,1,14],[2,13,2,14],[3,4,3,5],[2,16,2,17],[26,0,26,1],[33,1,33,2],[15,0,15,1],[29,0,29,2],[26,2,26,3]]}
["Boiler Cascade Schedule:",null,null,null,null,null,"1. Select model from drop-down choices in \"Boiler X\" box(es).\n2. Choose the variables (w/red headings) to complete the line item.\nNOTE: Cell values can be manually changed as needed. A new copy of the \nschedule will be needed to restore auto-population.",null,null,null,null,"This schedule is designed to be used for up to 8 boilers that will be in a cascade. This means a number of specifications will be the same for each unit.\nUse the drop down menus in columns with red headings to select the desired spec.\nFor units that stand alone, or are in a different area of the building; use the RESET button to create separate schedules."]
[null,"Boiler 1",null,null,"Boiler 2",null,null,"Boiler 3",null,null,"Boiler 4",null,null,"Boiler 5",null,null,"Boiler 6",null,null,"Boiler 7",null,null,"Boiler 8"]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27]
["UNIT DESCRIPTION",null,null,null,null,"BURNER",null,null,null,null,null,"WATER",null,null,null,null,null,null,null,null,null,"ELECTRICAL",null,"DIMENSIONS"]
["TAG","BOILER TYPE","MAKE","MODEL","AHRI EFFICIENCY","FUEL","INPUT\n(btuh)","MAX.\nOUTPUT\n(btuh)","MIN.\nOUTPUT\n(btuh)","TURNDOWN RATIO","MIN-MAX. INLET PRESSURE\n(IN. W.C.)","GALLON CAPACITY","MAX.\nPRESSURE\nRATING\n(PSI)","RELIEF VALVE\nPRESSURE\nRATING\n(PSI)","MINIMUM FLOW RATE (GPM)","MAXIMUM FLOW RATE (GPM)","DESIGN SYSTEM \nDELTA T\n(oF)","WATER FLOW (GPM)\nBased on ΔT","HEAD LOSS\n(FT. OF HD.)\nBased on ΔT","RETURN\nW.T.\n(oF)","SUPPLY\nW.T.\n(oF)","VOLTAGE/\nPHASE","TOTAL AMPS (FLA)","VENT SIZE\n(inches)","VENT MATERIAL","OPERATING WEIGHT   (lbs.)","UNIT DIMENSIONS\n(inches)\nH x W x D"]
[{"$f":"IF($C7=\"lochinvar\",\"B-1\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$O13:R34,MATCH(F7,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$J13:$M34,MATCH(F7,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,M4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,P4,FALSE),\"\")","v":""},null,{"$f":"IF($Q7=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q7=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q7=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q7=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q7=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q7=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q7=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q7=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},{"$f":"IF(U7=\"\",\"\",U7-Q7)","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C8=\"lochinvar\",\"B-2\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$O13:R34,MATCH(F8,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},{"$f":"IF($E8=\"\",\"\",F7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$J13:$M34,MATCH(F8,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},{"$f":"IF($M8=\"\",\"\",N7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},{"$f":"IF($P8=\"\",\"\",Q7)","v":""},{"$f":"IF($Q8=20,VLOOKUP($E$3,Lists!$AF:$AG,2,FALSE),IF($Q8=30,VLOOKUP($E$3,Lists!$AI:$AJ,2,FALSE),IF($Q8=40,VLOOKUP($E$3,Lists!$AL:$AM,2,FALSE),IF($Q8=60,VLOOKUP($E$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q8=20,VLOOKUP($E$3,Lists!$AF:$AH,3,FALSE),IF($Q8=30,VLOOKUP($E$3,Lists!$AI:$AK,3,FALSE),IF($Q8=40,VLOOKUP($E$3,Lists!$AL:$AN,3,FALSE),IF($Q8=60,VLOOKUP($E$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"",{"$f":"IF($V8=\"\",\"\",U7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C9=\"lochinvar\",\"B-3\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$O13:R34,MATCH(F9,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$J13:$M34,MATCH(F9,Lists!$J12:$M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q9=20,VLOOKUP($H$3,Lists!$AF:$AG,2,FALSE),IF($Q9=30,VLOOKUP($H$3,Lists!$AI:$AJ,2,FALSE),IF($Q9=40,VLOOKUP($H$3,Lists!$AL:$AM,2,FALSE),IF($Q9=60,VLOOKUP($H$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q9=20,VLOOKUP($H$3,Lists!$AF:$AH,3,FALSE),IF($Q9=30,VLOOKUP($H$3,Lists!$AI:$AK,3,FALSE),IF($Q9=40,VLOOKUP($H$3,Lists!$AL:$AN,3,FALSE),IF($Q9=60,VLOOKUP($H$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C10=\"lochinvar\",\"B-4\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$O13:R34,MATCH(F10,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$J13:$M34,MATCH(F10,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q10=20,VLOOKUP($K$3,Lists!$AF:$AG,2,FALSE),IF($Q10=30,VLOOKUP($K$3,Lists!$AI:$AJ,2,FALSE),IF($Q10=40,VLOOKUP($K$3,Lists!$AL:$AM,2,FALSE),IF($Q10=60,VLOOKUP($K$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q10=20,VLOOKUP($K$3,Lists!$AF:$AH,3,FALSE),IF($Q10=30,VLOOKUP($K$3,Lists!$AI:$AK,3,FALSE),IF($Q10=40,VLOOKUP($K$3,Lists!$AL:$AN,3,FALSE),IF($Q10=60,VLOOKUP($K$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C11=\"lochinvar\",\"B-5\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$O13:R34,MATCH(F11,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$J13:$M34,MATCH(F11,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q11=20,VLOOKUP($N$3,Lists!$AF:$AG,2,FALSE),IF($Q11=30,VLOOKUP($N$3,Lists!$AI:$AJ,2,FALSE),IF($Q11=40,VLOOKUP($N$3,Lists!$AL:$AM,2,FALSE),IF($Q11=60,VLOOKUP($N$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q11=20,VLOOKUP($N$3,Lists!$AF:$AH,3,FALSE),IF($Q11=30,VLOOKUP($N$3,Lists!$AI:$AK,3,FALSE),IF($Q11=40,VLOOKUP($N$3,Lists!$AL:$AN,3,FALSE),IF($Q11=60,VLOOKUP($N$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C12=\"lochinvar\",\"B-6\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$O13:R34,MATCH(F12,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$J13:$M34,MATCH(F12,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q12=20,VLOOKUP($Q$3,Lists!$AF:$AG,2,FALSE),IF($Q12=30,VLOOKUP($Q$3,Lists!$AI:$AJ,2,FALSE),IF($Q12=40,VLOOKUP($Q$3,Lists!$AL:$AM,2,FALSE),IF($Q12=60,VLOOKUP($Q$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q12=20,VLOOKUP($Q$3,Lists!$AF:$AH,3,FALSE),IF($Q12=30,VLOOKUP($Q$3,Lists!$AI:$AK,3,FALSE),IF($Q12=40,VLOOKUP($Q$3,Lists!$AL:$AN,3,FALSE),IF($Q12=60,VLOOKUP($Q$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C13=\"lochinvar\",\"B-7\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$O13:R34,MATCH(F13,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$J13:$M34,MATCH(F13,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q13=20,VLOOKUP($T$3,Lists!$AF:$AG,2,FALSE),IF($Q13=30,VLOOKUP($T$3,Lists!$AI:$AJ,2,FALSE),IF($Q13=40,VLOOKUP($T$3,Lists!$AL:$AM,2,FALSE),IF($Q13=60,VLOOKUP($T$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q13=20,VLOOKUP($T$3,Lists!$AF:$AH,3,FALSE),IF($Q13=30,VLOOKUP($T$3,Lists!$AI:$AK,3,FALSE),IF($Q13=40,VLOOKUP($T$3,Lists!$AL:$AN,3,FALSE),IF($Q13=60,VLOOKUP($T$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C14=\"lochinvar\",\"B-8\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$O13:R34,MATCH(F14,Lists!$O12:R12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$J13:$M34,MATCH(F14,Lists!$J12:M12,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q14=20,VLOOKUP($W$3,Lists!$AF:$AG,2,FALSE),IF($Q14=30,VLOOKUP($W$3,Lists!$AI:$AJ,2,FALSE),IF($Q14=40,VLOOKUP($W$3,Lists!$AL:$AM,2,FALSE),IF($Q14=60,VLOOKUP($W$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q14=20,VLOOKUP($W$3,Lists!$AF:$AH,3,FALSE),IF($Q14=30,VLOOKUP($W$3,Lists!$AI:$AK,3,FALSE),IF($Q14=40,VLOOKUP($W$3,Lists!$AL:$AN,3,FALSE),IF($Q14=60,VLOOKUP($W$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[]
["Schedule Notes:"]
["1.   Boiler shall meet ANSI Standard Z21.13 and thermal and combustion efficiencies and shall be AHRI certified.    "]
["2.   Boiler to be CSD-1 / Factory Mutual / GAPS, and California Code Compliant. "]
["3.   Boilers must be low NOX approved for South Coast Air Quality Management District Rule 1146.2 (for boilers up to 2000 MBH) and Bay Area Air Quality Management District. "]
["4.   Boiler heat exchanger shall be condensing, stainless steel, fire tube design.  No exceptions.  "]
["5.   Boiler shall be of a single burner and single heat exchanger design.  Designs with multiple burners and pressure vessels in a single jacket will not be accepted. "]
["6.   Boiler shall be CSA certified, at site altitude at high and low turndown ratio.    "]
["7.   Scheduled water volume is minimum allowed to prevent any increase in short cycling.   "]
["8.   Boiler shall not have a published excess 02% of more than 5.7%.  Excess 02% shall be validated by 02 sensor and readout on digital display.  "]
["9. Boiler shall feature Hellcat Combustion TechnologyTM which provides feedforward, feedback, commission trim, and learned trim via an exclusive O2 sensor platform. "]
["10.   Provide an ultra high turndown gas regulator on each incoming boiler gas line sized per National Fuel Gas Code."]
["Select Max. Gas Pressure   >>",null,"< Select >",null,"P/N =",{"$f":"_xlfn.IFNA(VLOOKUP(B3,Lists!B42:D49,MATCH(C27,Lists!B41:D41,0),FALSE),\"\")","v":""}]
["11.   Boiler must integral cascade sequencer with BACnet MSTP interface, lead/lag, efficiency optimization, and cascade redundancy.  "]
["12.   Boiler shall have 10” capacitive touchscreen interface with WiFi and ethernet connection for remote monitoring and control.  "]
["13.   Select Piping Configuration      >>",null,null,"< Select >"]
[{"$f":"VLOOKUP(D30,Lists!A17:B19,2,FALSE)","v":" "}]
["14.   Boiler shall be able to anticipate system load changes via a 0-10vdc signal from the variable frequency drive and boiler low voltage contacts. "]
["15.   Condensate neutralization kit shall be provided with each boiler. "]
["P/N =","< Select >"]
["16.   Pressure vessel and heat exchanger shall be protected by a factory warranty that covers lifetime thermal shock, 5 year on burner and 18 months on parts.     "]
["17.   Factory trained start-up and owners training required.  Full verification of specified turndown ratio shall be witnessed by owners rep.  "]
["18.   Standard Crest with Hellcat Combustion Technology Boilers are equipped to operate from sea level to 4,500 feet only. The boiler will de-rate by 1.4% for each 1,000 feet above sea level up to 4,500 feet. For United States isntallations above 2,000 feet elevation, reference NFPA 54 for derate information.    "]